/*
 Navicat Premium Data Transfer

 Source Server         : 本地mysql
 Source Server Type    : MySQL
 Source Server Version : 80012
 Source Host           : localhost:3306
 Source Schema         : message_board

 Target Server Type    : MySQL
 Target Server Version : 80012
 File Encoding         : 65001

 Date: 27/02/2020 21:37:21
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `add_time` varchar(255) DEFAULT NULL,
  `status` int(2) DEFAULT NULL COMMENT '1:超级管理员 2:普通管理员',
  `pass` varchar(255) NOT NULL,
  `ip` varchar(255) DEFAULT NULL COMMENT '当前访问ip地址',
  `is_open` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1:true 0:false',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=528 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES (520, 'admin', '2020-01-09 00:10:13', 1, '96e79218965eb72c92a549dd5a330112', '::1', 1);
INSERT INTO `admin` VALUES (521, 'mimi', '2020-01-09 22:41:06', 2, 'e10adc3949ba59abbe56e057f20f883e', '::1', 1);
INSERT INTO `admin` VALUES (525, 'da', '2020-01-16 01:41:01', 2, '96e79218965eb72c92a549dd5a330112', '::1', 0);
INSERT INTO `admin` VALUES (527, 'gogo', '2020-02-12 10:27:50', 2, 'e10adc3949ba59abbe56e057f20f883e', NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `u_id` int(11) NOT NULL COMMENT '评论用户id',
  `content` text,
  `add_time` varchar(255) DEFAULT NULL,
  `m_id` int(11) NOT NULL COMMENT '评论的留言id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of comments
-- ----------------------------
BEGIN;
INSERT INTO `comments` VALUES (51, 86, '这是评论功能！暂时没有表情包跟回复功能，表情包遇到的困难是h5端没办法监听键盘高度，没办法知道给表情区留多少空间，有经验的伙伴欢迎指点！', '2020-02-27 01:38:26', 40);
INSERT INTO `comments` VALUES (52, 87, '这个项目可以让大家说出自己的心里话，随所欲言，不用害怕别人知道你的身份，但是也要注意不要口吐芬芳', '2020-02-27 14:01:12', 40);
INSERT INTO `comments` VALUES (54, 87, '<span style=\"color: green; font-size: 20px\">测试内容，很酷吧，不错不错，味道好极了</span>', '2020-02-27 14:30:44', 40);
COMMIT;

-- ----------------------------
-- Table structure for dot
-- ----------------------------
DROP TABLE IF EXISTS `dot`;
CREATE TABLE `dot` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `u_id` int(11) NOT NULL COMMENT '点赞的用户',
  `m_id` int(11) NOT NULL COMMENT '点赞的留言',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dot
-- ----------------------------
BEGIN;
INSERT INTO `dot` VALUES (32, 86, 40);
INSERT INTO `dot` VALUES (33, 87, 40);
COMMIT;

-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` text,
  `add_time` varchar(255) DEFAULT NULL,
  `u_id` int(11) NOT NULL,
  `type` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of message
-- ----------------------------
BEGIN;
INSERT INTO `message` VALUES (40, '大家好，我是开发者，这是第一条留言，欢迎大家到来，这个一个简单的全栈项目，前端用vue实现，后台基于layui，后端使用node express实现的，项目比较简单，适合新手用来入门项目', '2020-02-27 01:36:06', 86, 5);
INSERT INTO `message` VALUES (41, '我也来发布一下最新内容，欢迎大家的到来，谢谢大家的支持', '2020-02-27 14:31:55', 87, 9);
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `pass` varchar(255) NOT NULL,
  `add_time` varchar(255) DEFAULT NULL,
  `u_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '1',
  `sex` int(1) NOT NULL DEFAULT '2' COMMENT '1:男 0:女 2:未确认',
  `ccount` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `token` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES (86, '靓B仔', '96e79218965eb72c92a549dd5a330112', '2020-02-25 17:55:50', '2', 1, 'yango', '5b93574bea49889378c29ef6ab41fe5f');
INSERT INTO `users` VALUES (87, '平头哥', '96e79218965eb72c92a549dd5a330112', '2020-02-27 13:57:47', '5', 0, 'yanki', '56dd3225165c01fb84002a76370fc483');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
